﻿CREATE TABLE [dbo].[event_target_audience] (
    [event_id]   BIGINT NOT NULL,
    [my_role_id] BIGINT NOT NULL,
    CONSTRAINT [PK_event_target_audience] PRIMARY KEY CLUSTERED ([event_id] ASC, [my_role_id] ASC),
    CONSTRAINT [FK_event_target_audience_event] FOREIGN KEY ([event_id]) REFERENCES [dbo].[event] ([content_item_id]) ON DELETE CASCADE,
    CONSTRAINT [FK_event_target_audience_my_role] FOREIGN KEY ([my_role_id]) REFERENCES [dbo].[my_role] ([my_role_id])
);

